<?php session_start(); 
/*
 * Session variables:
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 * $_SESSION['view_announcement'] [serial] = id of the announcement to be viewed
 */
if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
{   
    if(isset($_SESSION['type']))
    {
        if($_SESSION['type'] == 'administrator')
        {
           ?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View Announcement</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav { 
	  width:210px;
	  height:auto;
	  border:thin solid #09C;
	  margin-left: 10px;
	  text-align : center;}
	  
.mainline { 
	  width:712px;
	  height:auto;
	  text-align : center;}


</style></head>
<center>
<body bgcolor="#FFFFFF">
<body>

<div id="wrapper">
	<div id="header">
    <h1></h1>
    </div>
    
    <div id="header2">
    	<h3></h3>
 	</div>
  
	<div id="nav">
        <?php include 'admin_navigation.php';?>
    </div>
	
    <div id="mainline">
        <h4>View Announcement</h4>

  <div id="body">
  
	<div align="justify">
    
            <?php
            include ('connection.inc');
            $announcement_id=$_SESSION['view_announcement'];
            $sql = "SELECT * from announcements where announcement_id=$announcement_id";
            $result = pg_query($sql);
            
				$title = pg_fetch_result($result, 0, 'announcement_title');
				$timestamp = pg_fetch_result($result, 0, 'announcement_date');
               $time = date_create_from_format('Y-m-d G:i:s.u', $timestamp);
               $date= date_format($time, 'M-d-Y \a\t g:i a');
				$announcement= pg_fetch_result($result, 0, 'announcement');
                echo "  <h2>$title</h2>
                	<h5>$date</h5>
					$announcement";
        ?>    
 <br><br><br>  <form action="admin_manageannouncements.php" method="post">
                                    <input type="submit" id="back" name="back" value="Back"/>
                                    </form>
						
	</div>
	 </div>
	
      <p align="justify"><br />
      </p>
    </div>
    
    <br class="clearfloat">
	<br />
    
    <div id="footer">
    <p align="center">
    Tutorial Business Manager: info@tbms.com <br />Credits/Engineers: Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan; Manzano, Audrey Ann; Ng, Sheila Regine<br />
    <br />copyright 2011</p>
    </div>
</div>
</body>
</html>            
  <?php
        }
        elseif($_SESSION['type'] == 'student')
        {
            header('Location: student_index.php');
            exit();
        }
        elseif($_SESSION['type'] == 'tutor')
        {
            header('Location: tutor_index.php');
            exit();
        }
        elseif($_SESSION['type'] == 'parent')
        {
            header('Location: parent_index.php');
            exit();
        }
    }
}
else
{
    header('Location: index.php');
}
?>
